<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>How to filter data at the cross tab level</title>
    <link rel="StyleSheet" href="css/crosstab.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="ct-TutT6AddGrandTotals.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="mp-DesigningAMultipageReportIntro.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h4 class="N_hth_HowToHelp"><span style="font-family: &quot;Microsoft Sans Serif&quot;; font-size: 10.0pt; font-weight: normal"><a name="397918"> </a></span>How to filter data at the cross tab level</h4>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="397919">Select the cross tab.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="397920">In Property Editor, choose Filters and choose Add.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="397921">In New Filter Condition, specify the following information:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="397922">In Target, choose one of the following options:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b3_Bullet3_outer" style="margin-left: 28.3464pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b3_Bullet3_inner" style="width: 14.173199999999997pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b3_Bullet3_inner"><a name="397923">Choose Group level to filter data in a specific dimension, then select a group. For example, if the cross tab displays sales totals by product line and by year, you can create a filter to display data for certain product lines or for certain years.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b3_Bullet3_outer" style="margin-left: 28.3464pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b3_Bullet3_inner" style="width: 14.173199999999997pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b3_Bullet3_inner"><a name="397924">Choose Measure to filter measure data, then select a measure. For example, you can create a filter to display sales totals greater than a specific number.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b3_Bullet3_outer" style="margin-left: 28.3464pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b3_Bullet3_inner" style="width: 14.173199999999997pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b3_Bullet3_inner"><a name="469665">Choose Detail to filter on a field that is not used in the cross tab, but that is defined in the cube.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i2_Indent2"><a name="469074">In Filter Condition, the first field displays the expression of the selected group or measure. You can change this value.</a></div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="397926">Complete the filter condition by specifying the following information:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n3_NumList3_outer" style="margin-left: 28.3464pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n3_NumList3_inner" style="width: 14.173199999999997pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray2">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n3_NumList3_inner"><a name="397937">In the first field, select a dimension or a measure, or a group total for which to evaluate values. Alternatively, choose the expression builder button to create an expression.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n3_NumList3_outer" style="margin-left: 28.3464pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n3_NumList3_inner" style="width: 14.173199999999997pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray2">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n3_NumList3_inner"><a name="469637">In the second field, select the operator that specifies the type of filter test.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n3_NumList3_outer" style="margin-left: 28.3464pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n3_NumList3_inner" style="width: 14.173199999999997pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray2">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n3_NumList3_inner"><a name="397938">In the third field, specify the value to search in the dimension or measure specified in the first field. You can type a value, or choose &lt;Select value...&gt; to display a list of values. You can also specify an expression that evaluates to a value.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i2_Indent2"><a href="#397951" title="How to filter data at the cross tab level" name="397942">Figure&nbsp;16-14</a> shows an example of a complete filter condition. The filter limits the data to include only states not equal to CA.</div>
      <p class="i3_Image3"><a name="397949"><img class="Default" src="images/xtab_FilterCondition.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-14 New Filter Condition showing an example of a complete filter condition" /></a></p>
      <div class="fc3_FigCall3Title">
        <b class="Bold">Figure&nbsp;16-14&nbsp;&nbsp;</b><a name="397951">New Filter Condition showing an example of a complete filter condition</a></div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="397910">Choose OK to save the filter.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="591848">Preview the report. </a><a href="#591854" title="How to filter data at the cross tab level">Figure&nbsp;16-15</a> shows an example of the filtered report.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="591852"><img class="Default" src="images/xtab_FilteredReport.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 16-15 Cross tab report, filtered to remove data for sales in CA" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;16-15&nbsp;&nbsp;</b><a name="591854">Cross tab report, filtered to remove data for sales in CA</a></div>
      <div class="N_i_Indent1"><a name="591841">&nbsp;</a></div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>